Skip to main content

Duplication

1. Description​

The Duplication Derivation Type is used to validate for duplicate entries in specified duplication key columns.

2. Screen Configuration​

duplication_image

For the provided columns values it will form a key by joining the values using underscore and checks if the key is occuring more than one time. Let's assume CustId="C1" and AccNum="A01", then it will give "C1_A01" in the output.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The derivation type used is "Duplication".
    • req_fields
      • columns: Field names from the input metadata.